
https://www.nowcoder.com/practice/51c12cea6a97468da149c04b7ecf362e?tpId=82&tqId=29802&tPage=2&rp=&ru=%2Fta%2Fsql&qru=%2Fta%2Fsql%2Fquestion-ranking
insert into actor values
    (1,'PENELOPE','GUINESS', '2006-02-15 12:34:33'), 
    (2,'NICK','WAHLBERG', '2006-02-15 12:34:33');


https://www.nowcoder.com/practice/ae51e6d057c94f6d891735a48d1c2397?tpId=82&tqId=29760&tPage=1&rp=&ru=%2Fta%2Fsql&qru=%2Fta%2Fsql%2Fquestion-ranking
select distinct salary
    from salaries 
        order by salary desc;
        

https://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f?tpId=82&tqId=29753&tPage=1&rp=&ru=%2Fta%2Fsql&qru=%2Fta%2Fsql%2Fquestion-ranking
select * from employees 
    where hire_date=(select max(hire_date) 
        from employees);  


https://www.nowcoder.com/practice/ec1ca44c62c14ceb990c3c40def1ec6c?tpId=82&tqId=29754&tPage=1&rp=&ru=%2Fta%2Fsql&qru=%2Fta%2Fsql%2Fquestion-ranking
select * from employees 
where hire_date = (
        select distinct hire_date from employees
        order by hire_date desc 
        limit 2,1
);

https://www.nowcoder.com/practice/6d4a4cff1d58495182f536c548fee1ae?tpId=82&tqId=29759&tPage=1&rp=&ru=%2Fta%2Fsql&qru=%2Fta%2Fsql%2Fquestion-ranking
select emp_no, count(emp_no) 
from salaries group by emp_no 
having count(emp_no) > 15;
